Phase 2: Geographic Datasets

These outputs will provide information on local areas, 2013 area units, and statistical area 2 units, and 2018 Meshblocks.

Note that all longitudes and latitudes should be in WGS1984 format

Outputs

Four csv files:

Local area dataset

  1. Name (string is fine) Name
  1. Centroid longitude Centroid_lon
  2. Centroid latitude Centroid_lat
  3. Area (land only) Area
  1. Area zoned Residential under AUP Residential_area
  2. Area zoned Residential - Single House under AUP SH_area
  3. Area zoned Residential - Mixed Housing Suburban under AUP MHS_area
  4. Area zoned Residential - Mixed Housing Urban under AUP MHU_area
  5. Area zoned Residential - Terrace Housing and Apartments under AUP THA_area
  6. Area zoned Residential – Large Lot under AUP LL_area
  7. Area zoned Future Urban under AUP FU_area
  8. Area zones Hauraki Gulf Islands under AUP HGI_area
  9. Area zoned Business under AUP Business_area
  10. Area zoned Rural under AUP Rural Rural_area
  1. Haversine distance to Skytower from centroid Hdist_skytower
  1. Indicator (0 or 1) for whether local area is on coastline Coast_indicator
  1. Total population from 2013 census (sum of constituent meshblocks) Census2013_population
  1. Number of dwellings from 2013 census (sum of constituent meshblocks) Census2013_dwellings
  1. Average Household Income (weighted average of constituent meshblock household incomes from 2013 census, where the weights are given by the number of households in each of the constituent meshblocks in the local area) Census2013_avg_HH_income

Meshblock 2018 dataset:

  1. Meshblock numeric code Code
  2. Centroid longitude Centroid_lon
  3. Centroid latitude Centroid_lat
  1. Haversine distance from centroid to Skytower Hdist_skytower
  1. Minimum Haversine distance from centroid to coast Hdist_coast
  1. Manhattan distance from centroid to Skytower Mdist_skytower

OSRM API docs - http://project-osrm.org/docs/v5.24.0/api/#table-service

  1. Minimum Manhattan distance from centroid to nearest rapid transit stop (Northern busway, rail or ferry terminal). Mdist_rapid_transit
  2. Name of rapid transit stop identified above Mdist_rapid_transit_name
  1. Manhattan distance from centroid to nearest motorway on-ramp Mdist_onramp
  2. Name or other identifier of motorway onramp identified above Mdist_onramp_name
  1. Indicator (0 or 1) for whether the meshblock is on coastline Coast_indicator
  1. Total population from 2018 census Census2018_population
  1. Number of dwellings from 2018 census Census2018_dwellings
  2. Average Household Income from 2018 census Census2018_avg_HH_income
  3. Median Household Income from 2018 census Census2018_med_HH_income

Statistical Area 2 2018 dataset

  1. Name (string is fine) Name
  2. Numeric code Code
  3. Centroid longitude Centroid_lon
  4. Centroid latitude Centroid_lat
  1. Local Area in which the centroid is located Centroid_local_area
  1. Haversine distance to Skytower from centroid Hdist_skytower
  1. Minimum Haversine distance from centroid to motorway Hdist_motorway
  1. Minimum Haversine distance from centroid to rail line Hdist_rail